Table Register
The Concept Evolution system is based on a large back end database. This database contains all the Users, Preferences and data entered.
There are a wide range of functions that can be altered within the Table register; these include; how the text in the drop down menus is displayed or allowing hazards and documents to be associated. It is also the gateway to define compulsory or unique fields that are linked with each table.
System Administration > System Preferences > Table Register
The link will open the Table Register grid. It is a grid view which can be searched, sorted and customised as normal.
| General |
|
| Name |
The name of the table – it is highly recommended that Concept Evolution table names are not manually altered. |
| Maximum Page Size |
The maximum page size is used to limit the Users display options. Parts of the system are able to show grids of varying sizes, maximum page size puts a cap on this size. |
| Default Page Size |
The default page size is the number of records a grid shows. |
| Display Format |
Defines the display text shown on records on screens and drop downs. |
| Store Documents? |
Check the box to enable the entity to store documents. |
| Store Property Groups? |
Check the box to enable the entity to store attributes and properties. |
| Allow Hazards? |
Check the box to enable the entity to store hazards. |
| Display Events? |
Check the box to enable the entity to display events. |
| Store Attributes? |
Check the box to enable Smart Attributes to be stored against the table - Attributes module required. |
| Allow PMS Core Values |
Check the box to enable PMS Core Values to be stored against the table - PMS module required. |
| Publish Mobile Data? |
Check the box to enable to entity for mobile data to be published – GO module required. |
| Mobile Audited? |
Check the box to enable to entity to enable mobile audits - Go module required. |
| Store BIM Documents? |
Available from 4.6.0.0
Check the box to enable BIM Documents to be stored against the table - BIM Management module required.
Note: Grid and input panels for entities other than FLOCATE will not enable the tool bar buttons
|
| Allow Select All |
Available from 4.7.0.0
Check the box to allow all items on a grid to be selected by checking the box in the top left of the grid
Note: If this function is used within an assignment grid the "Assign Selected" should be used to ensure all entities are assigned. Using "Assign Page" will only assign the current page.
|
Complete the fields and click Save 
. From the Table Register header a sub navigation can be accessed to allow additional features to be enabled.
These include:
- Table Fields
- Validation Rules
- Translation Strings
Table Fields
Click to view more detail.
Within the Table Register specific fields can be modified to enable certain features.
System Administration > System Preferences > Table Register – Table Fields
The link will open the Table Register / Table Fields grid. It is a grid view that can be customised and sorted as normal.
To edit a Table Field, highlight the Table Field and click Edit 
.
| Field Name |
The name of the Table Field. |
| Description |
Free text description of the Table Field – by default these are blank. |
| Unique? |
Check the box to make this a unique Table Field (no two entries can be the same). |
| Audited? |
Check the box to turn on the audit trails for the Table Field. |
| Searchable? |
Check the box to make the Table Field searchable in the quick search function. |
| Full Text Indexed? |
If the field has been configured with full text indexing the box will be checked - This is a function available to SQL Server databases only and is configured at database level. |
Validation Rules
Click to view more detail.
Rules can be created to control data as it is entered e.g. Req IDs are unique or that email addresses contain an @ symbol.
System Administration > System Preferences > Table Register – Validation Rules
The link will open the Table Register / Validation Rules grid. It is a grid view which can be searched, sorted and customised as normal.
To add a new Validation Rule click New 
, to edit an existing Validation Rule click Edit . A pop up window will appear which will allow the creation or amendment of a Validation Rule.
| Rule Name |
The name of the Validation Rule. |
| Enable |
Check the box to enable the Validation Rule. |
| Failure Message |
Free text field to create the message a User will see it the Validation Rule is not met. |
| All States |
Check the box if the rule is to apply regardless of the state of the entity – if the rule is only to apply when an entity is in a certain state or states, un - check the box and click the required states. |
| All Applications |
Check the box to apply the Validation Rule to all applications – if the Validation Rule is only to be applied in Evolution and not Reach and Connect; un - check the box and check the required applications. |
| Field |
From the drop down select the field the Validation Rule is to be applied to. |
| Rule Type |
Select the radio button to set the rule type:
- Required Field – the field must be completed.
- Unique – the field cannot be a duplicate of another record.
- Field Comparer – the field data meets specific values or thresholds.
- Regex Template – the field must meet a regular pattern e.g. capitalised first letter.
- Regex Rule – the field must meet the expression typed here e.g. mobile numbers must start “07”.
- Read Only Field – the field is read only and cannot be edited.
|
Translation Strings
Click to view more detail.
Translation Strings are the thousands of labels from across the system. These can be altered to fit a business need.
System Administration > System Preferences > Table Register – Translation Strings
Highlight the translation string to edit, click Edit . A pop up window will appear which will allow the amendment of a Translation String.
| Resource Key |
Auto populated with the name of the Resource Key. |
| Value |
Editable value for the Translation String. |
